﻿using BwTMusicModels;
using HwjUIDI.Utility.DatabaseHelper;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace BwTServices.Theme
{
    public class ThemeServices
    {
        public List<North_Theme> GetAllThemes()
        {
            List<North_Theme> genres = new List<North_Theme>();
            string sql = "select * from North_Theme";
            using (SqlDataReader dr = DatabaseFactory.GetDatabase().ExecuteDataReaderSQL(sql))
            {
                while (dr.Read())
                {
                    North_Theme list = new North_Theme();
                    list =new ModelsHelper().GetNorthThemeModels(dr);
                    genres.Add(list);
                }
            }
            return genres;
        }    
    }
}
